/*    */ package com.qmsk.business.member.memberCouponBill.dao;
/*    */ 
/*    */ import com.qmsk.business.sys.basic.SupportDAO;
/*    */ import com.utils.gson.in.GsonHeadManyRows;
/*    */ import com.utils.gson.in.GsonHeadOneRow;
/*    */ import java.sql.SQLException;
/*    */ import java.util.Date;
/*    */ import org.springframework.stereotype.Repository;
/*    */ 
/*    */ @Repository
/*    */ public class MemberCouponBillDao extends SupportDAO
/*    */ {
/*    */   public int insertCashCoupoBill(String billNo, Long memberId, Long shopId, Double CashCpAmt, Long CouponRuleID, String getMode, Integer mberVday, String slName, Object bussId, String memo)
/*    */     throws SQLException
/*    */   {
/* 18 */     Object[] sparams = { memberId, shopId, billNo, CashCpAmt, 
/* 19 */       CouponRuleID, getMode, mberVday, slName, bussId, memo };
/* 20 */     return update("insertCashCoupoBill", sparams);
/*    */   }
/*    */ 
/*    */   public GsonHeadOneRow getRefundSingle(Object bissId) throws SQLException {
/* 24 */     Object[] params = { bissId };
/* 25 */     return getOneRowOfParams("selectSqlRefundSingle", "selectJsonRefundSingle", params);
/*    */   }
/*    */ 
/*    */   public Integer getCashCoupOfBillNo(String billNo)
/*    */     throws SQLException
/*    */   {
/* 36 */     Object[] params = { billNo };
/* 37 */     return queryForInt("getCashCoupOfBillNo", params, Integer.valueOf(0));
/*    */   }
/*    */ 
/*    */   public GsonHeadManyRows getIdOfBussNo(String billNo)
/*    */     throws SQLException
/*    */   {
/* 46 */     Object[] params = { billNo };
/* 47 */     return getManyRowsOfParams("getIdOfCouponNo", params);
/*    */   }
/*    */ 
/*    */   public Date getCrTimeOfIsAttention(Long memberId, Long shopId) throws SQLException {
/* 51 */     Object[] params = { memberId, shopId };
/* 52 */     return ((Date)queryForObject("SelectSqlIsAttentionOfmemberId", params, null));
/*    */   }
/*    */ 
/*    */   public int isExistByMemberIdAndRuleId(Long memberId, Long ruleId) throws SQLException {
/* 56 */     Object[] params = { memberId, ruleId };
/* 57 */     return queryForInt("isExistByMemberIdAndRuleId", params, Integer.valueOf(0)).intValue();
/*    */   }
/*    */ }

/* Location:           C:\Users\Administrator\Desktop\新建文件夹\WEB-INF\classes\
 * Qualified Name:     com.qmsk.business.member.memberCouponBill.dao.MemberCouponBillDao
 * JD-Core Version:    0.5.3
 */